UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b9iurNLdAq1s94/8Yf7N3Fetg0SswKd+PO3mHcTwCRU='
WHERE
key_id = 'b9067f7df4e71809f679ebfe47c2c05fd5369f608b48ce480f7f15c8014499ad'
AND (
token = 'b9iurNLdAq1s94/8Yf7N3Fetg0SswKd+PO3mHcTwCRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)