UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1Io5cP49PBg0pTQfv8sAglzkF/HeI3Jxa2SsjlPnB+Q='
WHERE
key_id = '87012e46a83bb1f92094ff254d1034bcc216f15c573356f236df3ecb44509ef8'
AND (
token = '1Io5cP49PBg0pTQfv8sAglzkF/HeI3Jxa2SsjlPnB+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)