UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZhvTCgI8TNEahsua1y416Cjv64znpH5YhsFO/U8wfmc='
WHERE
key_id = '9cece140ea66764dd72f8a4e9d3c43442f7627efe343a1cccc423b78069b3d7e'
AND (
token = 'ZhvTCgI8TNEahsua1y416Cjv64znpH5YhsFO/U8wfmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)