UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gBgr38H6jdY6Xc86228ZrMVRh7B3O9kZ006ovDn6XZs='
WHERE
key_id = '8c6061b0112a4561075152436abe25db32bf3562ab3a9475f601b97e72cf848d'
AND (
token = 'gBgr38H6jdY6Xc86228ZrMVRh7B3O9kZ006ovDn6XZs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)