UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HXrBNuvs7h7JpzEX83t76o/fWpdn+sH+lycTu/5yUkI='
WHERE
key_id = 'f19ade41f337188e118435edef1d1d0ad68c443fa505da6cc59d6b2e58513645'
AND (
token = 'HXrBNuvs7h7JpzEX83t76o/fWpdn+sH+lycTu/5yUkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)