UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7BfOfgpaWPMKo3MFpmzW9QMd1GeUbq8sZBzkxCrylRg='
WHERE
key_id = '32f5a2af6fb6951003df36ac26ff28502a3a1f32df40f0b43de8da149850d340'
AND (
token = '7BfOfgpaWPMKo3MFpmzW9QMd1GeUbq8sZBzkxCrylRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)