UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v7eA5Kz5pFssnhw4kl+nuhWd3FKmcNFGDVwIXN2ciiw='
WHERE
key_id = 'bd2f0b154bd68455227e6a2c5b40fd6a5d8b84cf6ed61fd0cbfd28ed02d4e4f9'
AND (
token = 'v7eA5Kz5pFssnhw4kl+nuhWd3FKmcNFGDVwIXN2ciiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)