UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a+6zyA7hsaa4ehDcx7GTmZvBOm1SnozAxQZjk9r7Oyw='
WHERE
key_id = '171d3398881e8aacdc59aeeae290863c8e7beb9c313806e4c3f751abeb952845'
AND (
token = 'a+6zyA7hsaa4ehDcx7GTmZvBOm1SnozAxQZjk9r7Oyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)