UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xzZ098QKnAWq4r7Ova3qwYCBqxYnYNwGwhIyzfRfsDU='
WHERE
key_id = '31c1752799e8d92d3ca4b9c782adf3b69a591ec31db5f7f971cb3b71372bcc9c'
AND (
token = 'xzZ098QKnAWq4r7Ova3qwYCBqxYnYNwGwhIyzfRfsDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)