UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tzy9R1YhWc39vKBjkhHym5HY68My2UnjWUMm+RIGtlg='
WHERE
key_id = 'e3d3eb84fa5d97478cf37d23a757b257a52115bbaacb032c16117ac43feb68f0'
AND (
token = 'tzy9R1YhWc39vKBjkhHym5HY68My2UnjWUMm+RIGtlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)