UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3cXjHpU9flkR3KGRUODZT3dOwkb0w7MrXA4rP8EpcoE='
WHERE
key_id = '9b1793dba1e4a01d1e6453186e7bccf0c2036ab4b77f8893c6ab6077d6ebdee3'
AND (
token = '3cXjHpU9flkR3KGRUODZT3dOwkb0w7MrXA4rP8EpcoE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)