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