UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pdZb48jkAhwt5v5oEY+v2ZB033P0hQoxeKH949soCyA='
WHERE
key_id = '9bb0b21c83ae262faa1e1a642e2efaa0843d8ce0682f6652d1ab1b6b82a7965d'
AND (
token = 'pdZb48jkAhwt5v5oEY+v2ZB033P0hQoxeKH949soCyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)