UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DKE5jITQ9gAytBdP/cWi4Qk2rXGxn5sBSm0+v62HFNs='
WHERE
key_id = 'c97553b0a4e4c6b6384bb01e1e3876d12d3daa683c756ada17f75b8c94cda9e8'
AND (
token = 'DKE5jITQ9gAytBdP/cWi4Qk2rXGxn5sBSm0+v62HFNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)