UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPRKmIb00nMpVAGi/1DzPpO9ySA8HS23xJzq7YWfqi4='
WHERE
key_id = 'fd9cc86d0f6daafc1d3e05202d20ce17aa27e7a5f38f37c11522d10a7a737622'
AND (
token = 'lPRKmIb00nMpVAGi/1DzPpO9ySA8HS23xJzq7YWfqi4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)