UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1OaVA/7u8aAaWGRDcYW2z6J/l7kDKMhbRhloOCcris='
WHERE
key_id = '237ffd7f25d80ba0f22c8f74363133a2848a6054cb0bfeb8ed1cce4b4e3007c4'
AND (
token = 'N1OaVA/7u8aAaWGRDcYW2z6J/l7kDKMhbRhloOCcris='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)