UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oKOYSxmx/NGdoC3wvgLgJjey6cAj/KmHC+I7EtN5+LU='
WHERE
key_id = '8de29f0b5ead451ee294e4ae94bcc6d401c0002450d4f6fd7c0235c983b85383'
AND (
token = 'oKOYSxmx/NGdoC3wvgLgJjey6cAj/KmHC+I7EtN5+LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)