UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJ5rzxwTxVHxXJL1bT/mJB55AUj1B8Zik8MpMiOfyJg='
WHERE
key_id = '6bc80765392de430d6aa04eb535deb505c83646278370c69f758a960656d4bb7'
AND (
token = 'gJ5rzxwTxVHxXJL1bT/mJB55AUj1B8Zik8MpMiOfyJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)