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