UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5CNEIEbi6m+Mler5eWGMmbSnEBCYFXuqlvsYHKstSM='
WHERE
key_id = 'a4d36b31c41001a6f8324d49132391a83395238e0aa9a33380c2519b5baea7b8'
AND (
token = 'G5CNEIEbi6m+Mler5eWGMmbSnEBCYFXuqlvsYHKstSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)