UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NiIT29ZqQbc5bZwo6H+bln8+LM0EnBkcS2iMBmhutV8='
WHERE
key_id = 'c60cceeb7558f923d6ce961cd5429dfb3029308fbea684443de62041eeafbf46'
AND (
token = 'NiIT29ZqQbc5bZwo6H+bln8+LM0EnBkcS2iMBmhutV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)