UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GRxwTzLjhDzPBMvtvQ93kFFOB1Lk7snu8aN5sHrrkPY='
WHERE
key_id = '47f857673eab0f1e857e882879752b39a2b416a0e58182d2e723d8143cc14849'
AND (
token = 'GRxwTzLjhDzPBMvtvQ93kFFOB1Lk7snu8aN5sHrrkPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)