UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DhFOAgDIgK86YHABS0QjaeK6uiocbSmFIVco1fHFDYc='
WHERE
key_id = '816f8e45c4905edba646f45cba37635cb0870f536a58f6f49b7ea9febdce1f88'
AND (
token = 'DhFOAgDIgK86YHABS0QjaeK6uiocbSmFIVco1fHFDYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)