UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfKYWT1zzrqm5B0/nkbQqU8EK3DtgD7eezoNSnKHU24='
WHERE
key_id = '59b512541047a8f71d128bb026e065373189e111876cc0d1664efa2cf2c5e1c7'
AND (
token = 'AfKYWT1zzrqm5B0/nkbQqU8EK3DtgD7eezoNSnKHU24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)