UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sTyGYh+ewT/edDZJaJHfDxO+GZt2yb6o/3Iske1AMzM='
WHERE
key_id = '57d27abd72a811803cbcba235a745b53a92bb649a3b29a64166e60b4346f805d'
AND (
token = 'sTyGYh+ewT/edDZJaJHfDxO+GZt2yb6o/3Iske1AMzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)