UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSiq36MAqYRjWGqeR48BVu1Dy13N1NPRNuL2ukS1q38='
WHERE
key_id = '777dc3b34910c5496bc202c8227836f5c71e8df29ccc7cad3c6cfe3622578770'
AND (
token = 'zSiq36MAqYRjWGqeR48BVu1Dy13N1NPRNuL2ukS1q38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)