UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTkQJqJJyC+jvrc6Dk6TDN1yGVU331zSdCKBrCvHShA='
WHERE
key_id = '8a8181a138b82fde82bcee8ec506b3b0f18923391d4151dd260126405ff6be07'
AND (
token = 'CTkQJqJJyC+jvrc6Dk6TDN1yGVU331zSdCKBrCvHShA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)