UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8enu0YvDHZMW+DssKzDzgHjhKv/eOeqUEZgC18VrOVM='
WHERE
key_id = '56c878a6e56d539475b2b0370a87427815d25bd4c5c8d569c800a49f15344078'
AND (
token = '8enu0YvDHZMW+DssKzDzgHjhKv/eOeqUEZgC18VrOVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)