UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jP6qzVWQG5y2cZ3vIOjQSz7GST8LwhAHkx2dZpKYykk='
WHERE
key_id = '28f6773ff2def42e7cc04727c55acbbfa729bf9ca158f4cbc4906f6b80aa7c5c'
AND (
token = 'jP6qzVWQG5y2cZ3vIOjQSz7GST8LwhAHkx2dZpKYykk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)