UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bPV7z+arVM0hFPJhwPWByM6nWGsbFwfCwq1lBKifQaE='
WHERE
key_id = 'd619e1f27c105b8297e1b5698084976ff38ad5cc0a89a1026333b58281c1ece0'
AND (
token = 'bPV7z+arVM0hFPJhwPWByM6nWGsbFwfCwq1lBKifQaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)