UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PW8kErqepn/sXwTIYh5CaD/dZWxd37vDguZC8lRKnyM='
WHERE
key_id = '02bce5038eef35c3b887e10196a9fb3bad6736da089600ebce3e8ac1e485a60e'
AND (
token = 'PW8kErqepn/sXwTIYh5CaD/dZWxd37vDguZC8lRKnyM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)