UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T5Dx8KFgAqijxuz3HnbUb9T0PK4e4iE8XanBv0v0FJk='
WHERE
key_id = 'a046f47062b93f33f36014b44eecb9dc7b0ab124e3db27acc7d05b51c4b7bd0f'
AND (
token = 'T5Dx8KFgAqijxuz3HnbUb9T0PK4e4iE8XanBv0v0FJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)