UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHldAI9h4VtXYCShInC2tY84i5UWMvBgMvgaziy094k='
WHERE
key_id = 'efbd17175ff2723075af2f5a9fc3e0ada240c06548e3d9525d8d642711a1386d'
AND (
token = 'pHldAI9h4VtXYCShInC2tY84i5UWMvBgMvgaziy094k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)