UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EJjpVZkmWFjMsMC0yBRZGxAbfPH7PpdfavxmtoK/mC8='
WHERE
key_id = '196058b9f1a65aa7fea785404ad0b41ad26f33c5f26adbc9a04799002194b157'
AND (
token = 'EJjpVZkmWFjMsMC0yBRZGxAbfPH7PpdfavxmtoK/mC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)