UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fG6irRVqLOBEPfn73JIFvOpzn9q/gKPJdc+HZYEcmBw='
WHERE
key_id = '59c6974614466ee37accf2adbd29608fdd97b0f1853458d97ee073922e9f5003'
AND (
token = 'fG6irRVqLOBEPfn73JIFvOpzn9q/gKPJdc+HZYEcmBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)