UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uTU8BzEkZAx6UCtGGh0KdoGNL7yBYLmQ8zNczH/qUtw='
WHERE
key_id = '854a5867a3569986f24cfb600fa2afc9916b60091f79964a177b828c0316076e'
AND (
token = 'uTU8BzEkZAx6UCtGGh0KdoGNL7yBYLmQ8zNczH/qUtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)