UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ChPor6fLnihZqutCCSNZXy+dSSvFKKVp6ZZkY31sVyo='
WHERE
key_id = 'd02076f1d5ad81920b546e1ebd4bfb7a400b95a4c7605d6fd736960e6852e2d7'
AND (
token = 'ChPor6fLnihZqutCCSNZXy+dSSvFKKVp6ZZkY31sVyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)