UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CXnfXsOSBBwME78ycYxGae+HsJ2aHoU4z4snp2No5qo='
WHERE
key_id = '77ebeec8a90ea3c4082efb8f47f928babcabbb665bf7195a97b7007558b2de5f'
AND (
token = 'CXnfXsOSBBwME78ycYxGae+HsJ2aHoU4z4snp2No5qo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)