UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qFIDJ9XlM52HpGNEG5njgmjpITv33I8/7MpfjrXZjX8='
WHERE
key_id = '7ce8599481ecaf2d9c1ecd7451b551a5437e6e0e5a4e169d2468ced180500a90'
AND (
token = 'qFIDJ9XlM52HpGNEG5njgmjpITv33I8/7MpfjrXZjX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)