UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJdEQnE2pOEvPhg2xXipMnVOZzukUN3v6dScxBux8Gg='
WHERE
key_id = '9045387b9928f1b50a2f6599477f0e64eb18b4aa692d933e64668a82644618dc'
AND (
token = 'ZJdEQnE2pOEvPhg2xXipMnVOZzukUN3v6dScxBux8Gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)