UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3fJJ2BtTsQR8tSD2pwR00WnBrSCVKOb4VMNDt4VK+ig='
WHERE
key_id = '4edb47ce8477017a368a0e3f719a63460e2a11f89e8b7b1a63c39ec26254b5a5'
AND (
token = '3fJJ2BtTsQR8tSD2pwR00WnBrSCVKOb4VMNDt4VK+ig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)