UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yr64/2mUyY7fmRK1CmtgcImzmbxUzMHvtnyK6JEmElI='
WHERE
key_id = 'bbe59a57c390465d40043f7226ecb8b630ae2325737e6dffd76c7878f6095231'
AND (
token = 'yr64/2mUyY7fmRK1CmtgcImzmbxUzMHvtnyK6JEmElI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)