UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBzS5sYa5qk8ebnaxLoFgzx8tJcm95pU1hNAJd1eNtQ='
WHERE
key_id = 'de6743d9ea7bbc72058e465824fb9fd9e2bcc5eda62861a52bb3c30fff6617f7'
AND (
token = 'pBzS5sYa5qk8ebnaxLoFgzx8tJcm95pU1hNAJd1eNtQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)