UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7hZ13bbrTe3klQFh/YlTDKtCLZsdh1iGIpJnyNd+CCc='
WHERE
key_id = '2cdda5465af895162d26045b769aa7832c026b6e3363dfd2c8da2a2debddc527'
AND (
token = '7hZ13bbrTe3klQFh/YlTDKtCLZsdh1iGIpJnyNd+CCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)